import outToExcel_Module as otem
otem.initWorkBook('班级表',a='所属班级',b='姓名',c='学号',d='性别')


class_info = [['1班','张三','1001','男'],['1班','李四','1002','男'],['1班','王五','1003','男'],['1班','赵六','1004','男']]

for item in class_info:
    otem.WriteToExcelFile(a=item[0],b=item[1],c=item[2],d=item[3])

otem.SaveExcel('D://test.xlsx')